Use this page to download csv files of the current data and/or metadata and edit edit as needed.
html`<i>${last_year} metadata and data for PI:</i><b> ${pis[indx].name} </b><br>Choose a different PI on the View Current Indicators tab`
last_meta='https://oceanview.pfeg.noaa.gov/erddap/tabledap/CCIEA_metadata.csv?dataset_title,indicator_title,long_variable_name,units,info_URL,institution,region,latitude,max_latitude,longitude,max_longitude,sampling_frequency,source_data_summary,additional_calculations,cciea_timeseries_id¤tly_served=1&principal_investigator_id="'+pis[indx].id+'"'viewof lastmeta = Inputs.button("Download "+last_year+" Metadata",{value: pis[indx].this_year,reduce: () =>window.open(last_meta)})html`<i>(This button will directly download a csv file of<b> ${pis[indx].name}${last_year} Metadata</b>)</i>`
viewof lastyear = Inputs.button("Download "+last_year+" Data",{value: pis[indx].last_year,reduce: () =>window.open("https://drive.google.com/drive/folders/"+pis[indx].last_year,"_blank")})html`<i>(This button opens the Google Drive folder containing<b> ${pis[indx].name}${last_year} Data</b>)</i>`
Use this page to upload csv files of new data and/or edited metadata as needed.
viewof thisyear = Inputs.button("Upload "+esr_year+" data and metadata",{value: pis[indx].this_year,reduce: () =>window.open("https://drive.google.com/drive/folders/"+pis[indx].this_year,"_blank")})html`<i>(This button opens the Google Drive folder for uploading<b> ${pis[indx].name}${esr_year} data and metadata</b>)</i>`
Select each indicator on the lower part of the page to see the current metadata
Is it correct? If so, there’s no need to download last year’s metadata
Does your metadata need updating? If so:
Go to tab 2: “Download Last Year” to download a csv file of your current metadata
Editing your metadata: edit the csv file as needed, but
Please keep the column headers as they are.
Avoid special characters. We may be able to deal with them but they can cause various issuess
If you import the csv file into a spreadsheet application (ie Excel) please export back out as a csv file
After you edit the metadata, go to tab 3 “Upload This Year” to go to a Google Drive folder where you can upload the new (csv) metadata
Expand
Download Last Year
Update your data
You can either:
download last year’s files and update them
or just upload new files (go to tab 3 “Upload This Year”)
Updating previous files:
Go to tab 2: “Upload Last Year” to go to a Google Drive folder where your data from last year is available
These files have been converted to standard CCIEA format. All columns in your original data are intact, however the CCIEA columns have been relabeled: “year, index, timeseries, metric, SEup, SElo” for yearly data or “time, index, timeseries, metric, SEup, SElo” for monthly data
Update last year’s files or use them as a template for this year
Consistent file names from year to year are important. This may mean removing the dates from the file names. The “NAME YOUR FILE LIKE THIS!” button (same as the “PI FILE NAMING CONVENTIONS” button) allows you to view and download a list of CCIEA file naming conventions for your data files. Contact Greg or Lynn if a file name is not listed for one of your data files
Expand
Upload This Year
Upload your new data
When your data is ready to upload (either the updated previous files or new files), go to tab 3 “Upload This Year” to go to a Google Drive folder where you can upload this year’s data and (optionally) edited metadata, both into the same folder
Now check your files to make sure they can be automatically ingested. Click button (4) to check the format of your files. A table will appear showing the status of your files. Please re-upload your files after correcting any formatting issues.